UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'brP7mlk5lySMv+4+/zz8o9BGdcSz0giXZp9ZhQH2AaU=' 
WHERE 
  key_id = 'a031094b85715c5c295d974053141bf79e92b749ff2ddafaee1ca11b60eee8f0' 
  AND (
    token = 'brP7mlk5lySMv+4+/zz8o9BGdcSz0giXZp9ZhQH2AaU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00017