UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZBdi7gO1kqr3ljI87ZeffcCEh6VI4Uo5j9oQCZ+B0JU=' 
WHERE 
  key_id = 'ac7e4554528a22e557639a9ec2380dc4e4db72ef2a09be4429956e32023eb43a' 
  AND (
    token = 'ZBdi7gO1kqr3ljI87ZeffcCEh6VI4Uo5j9oQCZ+B0JU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028