UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4h797t4fjNvw6OH83coQvs3wI2QyWavFZOAVB4HR1M0=' 
WHERE 
  key_id = '4b91440a5793623d8a1dc2ac2d27120abc22d9e48c0b2da8674036e538e9249e' 
  AND (
    token = '4h797t4fjNvw6OH83coQvs3wI2QyWavFZOAVB4HR1M0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00062