UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KnooMnZFSWnoYBfWKNKPMHzihuBlXbylUUl5tMvNXOo='
WHERE
key_id = '9079273f85881756ffc7bd22efd6b9c8a9aaa00cb35fb96fd93f99d6eab4319a'
AND (
token = 'KnooMnZFSWnoYBfWKNKPMHzihuBlXbylUUl5tMvNXOo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)