UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'X0CJ7TNB+iB+066IYTQrJEsftoK6IGPCTdgqOG6jNtA=' 
WHERE 
  key_id = '52f90b4b8d611c7d8519adc36404b570d9fb499284564ce8e49ea09ee077b4b4' 
  AND (
    token = 'X0CJ7TNB+iB+066IYTQrJEsftoK6IGPCTdgqOG6jNtA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031