UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'aGuZ1Z230jxxslDQUDWINEsuoIJpjev0JuVyOu32sCc=' 
WHERE 
  key_id = '0c66b2df012280cb3d30a080172d4ee5a94f3d1d88d4a1e4fd39b6d31b0710a4' 
  AND (
    token = 'aGuZ1Z230jxxslDQUDWINEsuoIJpjev0JuVyOu32sCc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035