UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5l9I8q67kiscdP8ovKXvQCs5yT+jCrNOqUuroH7vll8='
WHERE
key_id = '28d7439e08c21aed523735d23b66e2d1317388347eedd7b8f2c1075d929f5dfa'
AND (
token = '5l9I8q67kiscdP8ovKXvQCs5yT+jCrNOqUuroH7vll8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)