UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0h0+zVY4B/iFQP08S+Dk00KXBTsd4kHim6OPmflHHz0='
WHERE
key_id = '1a6fb47d0a7008936ad979ca181d06de3cd1196b3a3421448a9cafaa7a458865'
AND (
token = '0h0+zVY4B/iFQP08S+Dk00KXBTsd4kHim6OPmflHHz0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)