UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XxlyOfosg0ZMkId2ZQOZxV8Gj8tY8WjR0FZ+/5vaGPA='
WHERE
key_id = '6ba2e109d0e78d2f4bba94918ba726014cb99cdd9112a8606a275ad43a41d175'
AND (
token = 'XxlyOfosg0ZMkId2ZQOZxV8Gj8tY8WjR0FZ+/5vaGPA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)