UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'OOuZ1MPcem0PkAYGmCYH3K2A1g+R9sa6sRVmdoA6nZQ=' 
WHERE 
  key_id = '3e2e8c6ad0e3e299d04c83e217473e1c653a9728089e797125d6818e2bf2c2ee' 
  AND (
    token = 'OOuZ1MPcem0PkAYGmCYH3K2A1g+R9sa6sRVmdoA6nZQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025