UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gdg1zIX6uV23qYB4yQfEyAeQIpvB/mmcrhBE7Zv59xU='
WHERE
key_id = 'c9297bce65f3f623abda715cfa10f6e5d0744a15b4d524a430db861bd5603375'
AND (
token = 'gdg1zIX6uV23qYB4yQfEyAeQIpvB/mmcrhBE7Zv59xU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)