UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'b4Q82/vcoCE8f+TV+OqyO1BHI/5zNX3YxHz8D7wqEj0=' 
WHERE 
  key_id = '9a9d26e6c38ee4307bdfde5aa1e0b5a0801161386d7a658c7e99fe21da0bda45' 
  AND (
    token = 'b4Q82/vcoCE8f+TV+OqyO1BHI/5zNX3YxHz8D7wqEj0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035