UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'iVQ6ZEZN1FZIYEZAr4WcQ579UY3G6oipdw+FuYpKQ44=' 
WHERE 
  key_id = 'c7fe03a0fa65f86c72fc8469b4f55124526184bc10ec23d492ca908aea5abd23' 
  AND (
    token = 'iVQ6ZEZN1FZIYEZAr4WcQ579UY3G6oipdw+FuYpKQ44=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00056