UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xTh8Unm4nzp0G4W03bMVczgK8b0viuMe5MUwTC/jcTw='
WHERE
key_id = '3f02fe46fc42438385150e18e7edc413c7803b59b56f2bb2bdc602a0e281cbad'
AND (
token = 'xTh8Unm4nzp0G4W03bMVczgK8b0viuMe5MUwTC/jcTw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)