UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8D7ucawvSAM1a5+/zm2zz7cqpTFvHCJvMolzo1DeBn8=' 
WHERE 
  key_id = '1aa555ffdf05fa5ac30a6f1d14338504f1e3a6d2fcc934a60dab84e3e8ae38cc' 
  AND (
    token = '8D7ucawvSAM1a5+/zm2zz7cqpTFvHCJvMolzo1DeBn8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027