UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'fk7uC2gQ6sfBh1IrAhOCwfXsyT7IF0vqIFqQxvbaWfM=' 
WHERE 
  key_id = 'e0922da559be4ea5bc853ec7f31807c12569442435bcf1c25bdaddf9cf444440' 
  AND (
    token = 'fk7uC2gQ6sfBh1IrAhOCwfXsyT7IF0vqIFqQxvbaWfM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00049