UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'mXuzArO6uMa4pyIFBC0tOzs7fCxo1cP+zXGKiL4c6tg=' 
WHERE 
  key_id = '174bdb2c2b5bb598f3300b2e39bb23abb9fdfcfcb553705cb119e8c257c35f15' 
  AND (
    token = 'mXuzArO6uMa4pyIFBC0tOzs7fCxo1cP+zXGKiL4c6tg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031