UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'X8pPQbzYLq/1ONQHnui9Zm3zndDOL40hZ7Kl6NeGIMI=' 
WHERE 
  key_id = '12bb273255d779d84492e86c28aa8d791f5a28042f2641e220c77acfbb4e8d03' 
  AND (
    token = 'X8pPQbzYLq/1ONQHnui9Zm3zndDOL40hZ7Kl6NeGIMI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027