UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gGNo+18TskaIRfxDkXfaZN9Fymeqf8+qsaH7BFZhMT0='
WHERE
key_id = 'c9687aa8ef2263db13e4e039f2d2665f66adc443b971d31ede538c3e3b69d0a5'
AND (
token = 'gGNo+18TskaIRfxDkXfaZN9Fymeqf8+qsaH7BFZhMT0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)