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

Query time 0.00035