UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tpYhQTAnX1nYGfr0go48PdhvbO1vYI60vK3QWHHmXc0='
WHERE
key_id = 'b46e2cbd4d0b88f81ea7c055fd1db3463186a9b69e14cf9bb584050be1d08682'
AND (
token = 'tpYhQTAnX1nYGfr0go48PdhvbO1vYI60vK3QWHHmXc0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)