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