UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'O6is2nU7vNlzyzJPCsOf3+9yAKO8oeYd1kX/FhcVhuc=' 
WHERE 
  key_id = '6ca07e1d5946e3ac8cdc2b9aaafc5f095293f9117ee76ff2c05815a791e29843' 
  AND (
    token = 'O6is2nU7vNlzyzJPCsOf3+9yAKO8oeYd1kX/FhcVhuc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025