UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zE0DfasH8sOt7xefogTLRt0yCgPu2Kiogemcw3LR6+E='
WHERE
key_id = 'd32a9e4c72e0d3c775fe3518fe7565d06e84fd3bc8a2ccde8a253094b3fb4fcc'
AND (
token = 'zE0DfasH8sOt7xefogTLRt0yCgPu2Kiogemcw3LR6+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)