UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BTtgl2EfZ2tQ2TuUIGJRikjsLYkOw3MH9Ocqpe2B8E8='
WHERE
key_id = 'b4c1ffd219832fe5566c2c7493659385c6aadb72e209ffe1e6b2ab686653462a'
AND (
token = 'BTtgl2EfZ2tQ2TuUIGJRikjsLYkOw3MH9Ocqpe2B8E8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)