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