UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'XxlJ4xm9Ejmk/GfqAt4tgchtqS5dC692aSBMs1xEfCA=' 
WHERE 
  key_id = '11058c0f9e8e798ceaebd20a4092c35d01a7f6783af2c81c659d83f9159bcb8a' 
  AND (
    token = 'XxlJ4xm9Ejmk/GfqAt4tgchtqS5dC692aSBMs1xEfCA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034