UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'J9ZvBsEkxW25wYzwiaq01tm/D5hW6HF0J4BTFIdfOdo=' 
WHERE 
  key_id = '0e67fabb9c6725c1cd0f380839301f411161d768040a4cc61ab7c0e83b378909' 
  AND (
    token = 'J9ZvBsEkxW25wYzwiaq01tm/D5hW6HF0J4BTFIdfOdo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029