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