UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AYFErMqKgMD9yGxYqAeCmHqC/xKm5xQU5EWjxLpD3hA='
WHERE
key_id = 'c48f0e894bf811b17a556b0e3027bbea474ef484c3b1e4d4738b892dcc1947d9'
AND (
token = 'AYFErMqKgMD9yGxYqAeCmHqC/xKm5xQU5EWjxLpD3hA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)