UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sUwW+y6k2HpmuLVSIdJXqdl6ZRrVzOyl6HwIZfARjTw='
WHERE
key_id = 'f415f45f833c2ef489a3ebd74c05737f7440e1ddeff7f8e3275ab938df682a5c'
AND (
token = 'sUwW+y6k2HpmuLVSIdJXqdl6ZRrVzOyl6HwIZfARjTw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)