UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nIM4r949n3WSsHNU4TohB4QpYFRJr0TJ/G484wwo8FU='
WHERE
key_id = 'e5c2ae235048395583972e9a814e3f299d34b0d864d62db88d140af4b2e6e24f'
AND (
token = 'nIM4r949n3WSsHNU4TohB4QpYFRJr0TJ/G484wwo8FU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)