UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'adgZYglo1wZ/xV8Un9bIzodBNuTMQGKCHariZhY/aOc='
WHERE
key_id = '53f5e2a9dc7a5c03922bde57bd42c8f662618dfcdac6bc31067fab3fd2e3847a'
AND (
token = 'adgZYglo1wZ/xV8Un9bIzodBNuTMQGKCHariZhY/aOc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)