UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Q1Ap2Klyf6/QxZEJD+UJZWRSo8S1UDYeDXKt7IU3C8='
WHERE
key_id = 'ddcd04fd4e3e5495e14632134299ad7c96dff7e0a1b1e1d4bf75b1f7967987f4'
AND (
token = '3Q1Ap2Klyf6/QxZEJD+UJZWRSo8S1UDYeDXKt7IU3C8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)