UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'WkE/VC8eJSSCHghjIlnWghx2K/Axmv+0+mkqouZBdbE=' 
WHERE 
  key_id = 'd8a064adefcb0c261e9c46acf6cfbc9e0cd163b7b442ca160f60f535d323cde9' 
  AND (
    token = 'WkE/VC8eJSSCHghjIlnWghx2K/Axmv+0+mkqouZBdbE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044