UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'lV40P+Odq1y2TLUoSLCyV7d49n0a5UXN/SrooLX7d4Y=' 
WHERE 
  key_id = 'a1dd8c552449a876bef4967fc67029d285c73ad1ca6d800577ba74cb34e8d377' 
  AND (
    token = 'lV40P+Odq1y2TLUoSLCyV7d49n0a5UXN/SrooLX7d4Y=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044