UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TfpHNPj7iZ38Kt0btQcf81M9qaKa3jhdC5neEETejuE='
WHERE
key_id = '7f8748063bf3f0271d298e524a7dbc6865c1383b08ac24a14147e97ab798765a'
AND (
token = 'TfpHNPj7iZ38Kt0btQcf81M9qaKa3jhdC5neEETejuE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)