UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'LD56N+VbBJd3x8Ih6Ydk6We9l7aOYpve8AQgNat6Fts=' 
WHERE 
  key_id = 'bdca823bbe10bd2ecc6b590a8b161563740e794261764df29446ff0a2ef10041' 
  AND (
    token = 'LD56N+VbBJd3x8Ih6Ydk6We9l7aOYpve8AQgNat6Fts=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023