UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'rPU9j55Z4Dis31Th2B5SjgtlrFgv1h0Nwao3Uhl0u58=' 
WHERE 
  key_id = '418022c0e22152d5169ef57536edac7e13a5b90f6792c8b19bf3322d8976d671' 
  AND (
    token = 'rPU9j55Z4Dis31Th2B5SjgtlrFgv1h0Nwao3Uhl0u58=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042